package org.sakai.mapper;

import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;
import org.sakai.entity.User;
import org.sakai.entity.vo.UserVO;

/**
* @author Sakai
* @description 针对表【user】的数据库操作Mapper
* @createDate 2025-06-19 22:44:59
* @Entity org.sakai.entity.User
*/
@Mapper
public interface UserMapper {

    int deleteByPrimaryKey(String id);

    int insert(User record);

    int insertSelective(User record);

    User selectByPrimaryKey(String id);

    int updateByPrimaryKeySelective(User record);

    int updateByPrimaryKey(User record);

    @Select("select * from user where id = (select id from user where email = #{ email }) ")
    User selectByEmail(String email);

    @Select("select * from user where id = (select id from user where phone = #{ phone }) ")
    User selectByPhone(String phone);

}
